SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 902010 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 902010 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292574,526651,984577,1035551,922201,530497,228584,8328,338783,384577,866085,707816,994253,688258,109428,65611,786479,263165,282019,848682,975265,452167,960054,1037522,1024733,386103,126529,132716,151030,131156,418708,303102,453446,1012790,791144,864573,483420,77311,659253,276259,25351,550930,786036,759515,582039,168487,969543,32261,228971,774553,992479,525255,781196,660822,1034279,28547,960756,532952,447548,466658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 902010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 902010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001116s ]