SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535188 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535188 [ RunTime:0.002341s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920199,852579,150753,382919,956482,5718,149036,230602,621380,381032,204814,789069,743768,339287,581783,1026572,85849,463906,904944,81202,770234,423725,543512,381122,984162,116212,882227,78038,820334,623844,737741,132930,1017914,472274,783315,292261,583667,585705,231148,640019,828841,98251,65637,447435,695238,240894,845703,756188,397821,694377,634307,427044,70192,982474,345049,634603,868641,793404,809122,633249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]