SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565611 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565611 [ RunTime:0.006223s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774713,238410,459758,853946,379534,936815,216873,566963,301010,121308,101897,1012584,84777,876193,445863,66423,944167,45201,1039806,602543,421713,913886,943579,635322,47549,552447,832892,496166,197311,399361,355925,510698,881444,622996,776545,130816,931672,10397,132423,492368,572873,946972,837398,78056,685908,606816,504222,147373,166684,819152,521340,366337,137106,408477,351495,846260,499030,46933,952778,780450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]