SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516010 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516010 [ RunTime:0.002020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575106,758906,174050,270242,134909,162171,815325,371352,782448,251529,345991,380754,244992,523479,169477,636149,559733,353554,390035,709136,404447,852561,998913,807581,1016488,1045479,533145,784305,396551,888134,103993,276832,446180,483621,676373,358264,194041,566945,290306,182283,634809,960208,107621,304447,89782,308369,398769,818145,247125,255777,717859,541750,401805,881993,706903,543591,648534,606732,757854,343306) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]