SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003791s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294685 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294685 [ RunTime:0.002161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (90436,124316,579814,749330,413420,672029,862214,653316,700315,140199,915328,897340,51060,159038,528731,706038,623786,905459,692042,341982,675723,108887,336291,582587,803054,433758,31779,183137,152136,918426,164919,235238,163135,988628,442671,503029,705442,463101,660158,133829,23407,1014274,518041,24282,673208,973929,888265,67623,1022646,252374,1039889,908803,498653,342480,821506,962115,828105,1006475,338929,100030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]