SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 168561 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 168561 [ RunTime:0.002265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286418,632768,454236,326852,787611,262998,994479,257289,545520,861116,1013891,728440,179686,384393,914557,123951,299116,125157,507415,980509,506715,665311,181619,783745,745892,330450,994889,525803,591410,108406,612193,590979,370894,461717,234004,63781,485462,115781,698279,579570,762151,288709,71922,594433,808139,759398,56,440944,715870,17208,99297,477034,421345,523218,383113,1030422,757396,646497,725078,200564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 168561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 168561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]