SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426213 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426213 [ RunTime:0.001420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302498,814385,714646,70684,900587,922448,153643,673046,954777,689376,495638,633695,568238,355463,451121,432664,870275,118829,393801,417766,202180,1009657,84647,300917,564405,991258,412929,259658,158005,832154,81145,864392,335264,598886,810648,603120,392541,322635,943263,817174,683052,690627,399887,136434,703137,245680,573961,464436,605240,229718,223134,676280,698491,977386,852560,194143,486056,104242,681562,135530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]