SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54886 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54886 [ RunTime:0.002451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550208,144516,417778,559471,116676,568808,501105,881552,660237,740176,506787,468695,573251,688737,653643,425708,313167,458685,408599,310522,59020,25094,170414,540350,760066,107943,1043603,204787,176218,401128,943211,258802,329731,229504,351841,868551,772480,435311,544908,290632,241643,25655,287620,737233,841520,179254,103585,805978,253912,1034817,558689,572491,1002378,979390,58326,908555,118657,922579,516455,862352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54886 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54886 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]