SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451984 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451984 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516496,670168,531219,1018321,1040194,322526,1031912,881355,619264,10429,65927,372433,325100,347068,318321,501176,732529,798460,3814,36631,667620,997465,864460,917419,221439,333035,981150,928159,959125,728026,162351,21002,707342,72956,1036725,741230,214237,837313,408390,137743,133789,1029709,69898,264238,832282,918506,926421,98642,553847,458587,677147,307570,56466,726577,674655,723911,466754,966672,43119,13943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]