SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432683 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432683 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100120,103907,954722,557609,988448,56530,491872,847706,342204,405322,843882,75871,259336,256188,498781,870380,751373,857107,852099,984660,563256,956875,211875,223000,569334,214602,508556,354984,497524,982594,387157,685801,788300,388553,496674,276900,790863,602358,861434,861506,179898,104634,531227,116014,1020692,752555,620941,753540,109592,619806,828130,908348,973348,597527,380416,973673,315813,376345,852504,32183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001274s ]