SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001602s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400028 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400028 [ RunTime:0.002735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285056,978842,561202,452879,536194,292243,475949,724081,96976,779329,354972,659400,79812,1045910,585570,175433,797659,44400,42382,422226,556354,133314,417896,777078,950469,373826,203463,633368,290157,403164,837620,874785,925451,440684,238909,1031676,155857,613272,628010,778145,411443,928767,955293,323268,168641,1033254,448895,654603,287944,426452,5249,883612,231052,654597,99345,335829,68815,971857,526137,675257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]