SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001795s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517054 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517054 [ RunTime:0.002423s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021981,556030,397908,971830,883108,470070,750200,496023,190509,1043236,26886,863291,530177,854439,513115,402777,194801,181244,667542,489707,922104,905443,130881,970705,852079,717456,584987,934105,982564,85234,513443,903687,888550,417353,66748,1012107,911345,859571,8407,594135,1009250,110360,625449,366595,1009731,166098,111140,694395,611163,1006505,665556,120759,153135,31712,766320,277484,896200,336610,292598,417010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003769s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003955s ]