SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106213 LIMIT 1 [ RunTime:0.002456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106213 [ RunTime:0.002425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250664,606344,643634,976152,843076,90291,196128,758871,972035,458971,563141,98192,444846,930565,722177,277134,211314,432194,749500,438923,851950,777942,608477,390214,454622,908966,1044612,786800,615185,820142,823868,211273,697774,687396,970012,905333,1003302,392677,575369,829875,574534,277492,878241,877694,27431,100584,1016166,1026896,932822,222993,498268,629366,799327,868767,437043,609114,400659,39470,344182,606319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]