SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002529s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108197 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108197 [ RunTime:0.005902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019670,1015527,930345,217536,221186,656348,994661,919337,702709,610604,953470,787020,351642,1042915,996119,679527,202086,933215,370133,74750,441865,604549,35937,986299,467370,175947,386726,550409,492200,153985,525318,1046095,1014056,482381,563783,695556,570724,246700,415733,363199,297986,691905,1011839,384636,11053,715842,138602,935536,431826,946249,1908,1013782,881943,749444,927258,355076,854551,759334,638692,793428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002840s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]