SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517894 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517894 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048598,528478,469903,415916,813483,381635,303762,741111,266217,479504,593518,332485,830168,104154,525072,320351,303317,798261,237888,580061,407624,101409,115368,737473,558214,46727,81253,487362,502351,438981,492034,587754,545506,88769,189366,483922,74890,802108,810442,840658,771554,580075,258711,1039751,95973,254540,104639,566976,502797,7371,591010,500979,412076,189875,184471,129697,497830,298179,214178,955727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]