SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510307 LIMIT 1 [ RunTime:0.000553s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510307 [ RunTime:0.002541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507897,388542,3783,485895,522803,246074,296898,468999,676921,478311,334613,824971,852505,423327,945533,120411,498375,559526,1015008,888628,1016795,400334,990715,464213,266614,217735,1039498,301963,872387,122434,577102,467081,357811,217836,7651,239242,754413,378129,189767,472926,1014403,603077,875734,465107,5938,1017890,441478,83673,571354,98483,37094,672757,1004554,462134,403424,297035,498285,1044315,257468,25305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]