SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027433 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027433 [ RunTime:0.003446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (740225,339438,776987,964470,453302,32119,977289,508640,629914,499352,853702,499049,855675,50450,593368,648693,131179,1016580,318709,791112,851611,556719,698809,896081,733487,485747,312901,534199,450759,1006981,155454,188351,1046467,683688,1024901,607107,7080,707910,196099,371190,117099,364340,507138,502796,1024036,984078,228042,55052,462106,562015,140741,499877,146852,294922,159738,552833,430926,461101,39550,915300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000736s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]