SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348493 LIMIT 1 [ RunTime:0.000468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348493 [ RunTime:0.002263s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521688,61169,409697,288044,224880,98892,872621,728966,779313,108468,313274,843967,266175,509249,83455,42902,698624,600949,668029,712279,481126,21954,211443,116443,759023,163982,515496,982637,106283,394775,601994,818389,988548,401722,255970,471183,561801,11628,838874,373219,517259,537084,902508,184591,413947,215594,504157,319942,147008,514037,586630,663988,83223,1015796,1029206,38305,53140,42953,689712,1043312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]