SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 938580 LIMIT 1 [ RunTime:0.002546s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 938580 [ RunTime:0.012331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116021,252948,355435,855184,167693,779450,42029,818254,960027,866362,455816,750641,916638,976912,542017,406118,681588,543103,1013433,118562,246818,599968,232822,850524,992184,246676,243047,927688,282366,766041,1012607,195827,240706,770686,772324,601896,122845,314934,865243,112104,807244,268029,668132,645907,764916,97684,448294,465536,400524,261001,253023,568162,571076,591554,364329,792115,1009553,180698,136701,333113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002695s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 938580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 938580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002162s ]