SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001994s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44584 LIMIT 1 [ RunTime:0.003493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44584 [ RunTime:0.004861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245066,269964,466533,241900,399635,257144,161980,977334,382620,51533,577288,37207,569902,269312,995378,114463,15649,905659,572855,840061,418314,148854,633617,226000,739621,909630,921549,291359,119823,22989,426007,469574,468484,196949,775386,328954,478063,9233,455199,233111,83760,463100,58813,23390,918350,77730,223342,62252,635416,889938,193409,605410,143444,714841,413956,793303,67142,694206,654576,621153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001268s ]