SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354164 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354164 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221141,538152,710901,1038252,980373,1016738,168407,24754,157825,1027526,231377,553499,305538,472274,659648,266442,687773,399488,755822,850141,1512,542844,791974,664173,537882,572085,55295,541650,348040,701152,723800,730318,305818,428575,893522,1013669,288074,761121,1042449,519325,438480,213987,403089,999019,209158,115949,889757,961395,694722,615077,698305,199946,403796,437369,842532,979204,259399,501605,498963,341348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002545s ]