SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981309 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981309 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798504,118018,27882,144718,366417,962835,923082,419968,953001,584349,158718,695046,885031,285304,373922,99516,462836,249855,125727,550272,985433,235048,224317,250782,506725,567447,630214,804183,657322,1033912,650391,415180,104119,720308,1015663,588997,84058,405629,707609,1035336,722536,179654,561910,252738,89483,776113,529093,928722,699373,128938,877316,866011,456725,975112,551239,253864,695556,698708,920627,839776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001255s ]