SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516521 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516521 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844345,240390,1008202,12161,101835,574011,619430,385075,20027,1014181,511936,918243,388591,19382,583080,435231,1001577,709,27948,595083,209167,480717,879,75091,958544,207336,58895,744442,6286,440186,890462,656669,282166,336666,48963,574845,148454,499154,620423,966077,739715,401459,341302,350146,462209,145758,388145,386225,417674,972229,218930,689578,315588,582283,833143,1023282,274029,271204,861864,399199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002758s ]