SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105920 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105920 [ RunTime:0.002662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248787,956310,662942,772790,587948,243554,671125,970647,869018,143760,587642,756867,911136,1035085,752693,132997,710186,71574,766115,756424,582849,569287,232170,907236,309295,45429,1019943,905859,623750,512524,615144,655303,910485,487530,353833,110107,114075,769614,870094,1032899,338474,715635,398128,293081,26890,136050,178619,984025,923055,698844,10151,457990,626416,818063,33924,613917,732398,745062,792347,992459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]