SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002483s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 211218 LIMIT 1 [ RunTime:0.002523s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 211218 [ RunTime:0.004161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262521,1001196,899349,124888,1045519,627879,915491,395463,809934,479169,280139,809235,7685,221260,31964,285149,536218,385139,688114,325354,1023382,724006,65832,1007288,609903,524081,859918,395135,80952,449955,910180,58171,928112,455732,732726,53463,693043,429655,939473,959804,844127,1026199,382274,190473,342261,961715,508056,318837,886941,627412,952826,959907,149902,410608,1047907,373050,386548,220001,156267,492237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 211218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 211218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]