SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 250003 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 250003 [ RunTime:0.002032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360109,429481,446272,441967,915480,885654,308591,5585,531716,448276,43453,510239,111402,74410,544494,37356,323592,493817,12699,112144,1024114,566302,671308,594685,533620,360892,598943,506429,791968,204175,1027159,590868,48413,122907,155777,652632,553734,537056,906625,729609,454694,811841,981188,318471,947572,675780,263053,265670,207911,353177,612113,1015439,841805,623726,548764,119556,290732,641960,969777,994978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 250003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 250003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]