SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517528 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517528 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045380,921725,85037,526547,574271,527476,62487,595314,345390,194294,454985,861766,662803,881623,280019,66118,907319,537706,208642,746422,256177,377123,695454,672778,407238,110472,448193,1015940,107720,221800,264778,447955,765779,284723,583559,430208,152167,863534,865169,475606,555623,290601,71518,125,874482,572544,39205,269833,1027254,810776,511557,430493,627220,373250,367834,36750,712429,357546,777254,912743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]