SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545739 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545739 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872137,511315,66923,631261,314026,678723,261750,1002220,699150,510644,78569,1017921,3604,1024571,916626,199140,873872,241401,908832,428857,820548,402557,753516,281521,717327,881370,10377,593393,884584,606189,204015,75170,248209,337219,34248,127,1035297,745132,12454,7059,578306,488985,515860,464452,433567,510274,552493,708147,766010,18136,552937,39307,858327,448643,558583,185891,214134,648196,506504,969177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]