SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402463 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402463 [ RunTime:0.001507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689844,760693,46748,757009,679796,252739,200712,997454,803503,275887,379821,910460,199042,644562,459377,956788,849543,985852,156167,392138,806312,774890,342190,680487,388545,496881,13347,570072,764496,481343,958245,741083,604579,254300,559564,139076,19340,95453,205375,151469,789430,86728,369791,968574,45380,222356,611891,925127,450453,27968,840612,560407,901051,337600,438569,845588,685512,240330,821428,455537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001484s ]