SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000883s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418834 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418834 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981326,670467,1009780,579538,745413,115370,885841,644261,888653,801991,1041821,923072,869832,422741,403161,490060,817307,73122,294154,594391,465919,169558,826192,855326,116290,249442,565152,483093,817854,565853,674916,257481,274980,717092,577868,414862,1032925,718157,967536,709301,940879,642276,509992,398156,911430,148477,362013,199872,675715,411688,336367,595314,996995,652758,1015070,420903,286554,535089,346562,913267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]