SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448108 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448108 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595413,1029920,691656,810118,1019681,490304,136184,805366,642587,731649,437656,144059,398168,745213,445773,823496,829174,489782,612770,545886,121090,449808,608097,42723,1043765,276165,332004,248572,48238,27842,423900,768411,139258,230481,752335,360865,248646,230182,93181,983613,962027,889203,98315,125735,197565,664452,974697,609859,1044409,880846,958677,736614,534172,134872,807646,338639,323340,288928,376047,656500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]