SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 790311 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 790311 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266121,219260,702578,313383,982557,1016912,350509,241686,242948,782325,200154,887697,103878,437873,807094,219143,717184,325300,571666,963235,159020,1040790,627573,936225,484212,489320,650018,632083,718291,670603,382202,856784,636358,508493,211293,1034503,596191,211690,399980,104418,986389,611762,1005898,216926,115218,661588,344701,112065,892490,264019,674706,462359,956896,531935,613860,1035864,563726,1046053,121276,250441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 790311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 790311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]