SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482500 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482500 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428249,74287,900595,1044781,142179,866280,499393,348517,705937,278164,190476,829273,827364,422121,809918,161613,632822,992815,110450,360412,1029262,754020,493793,8189,228410,981089,877545,14978,624512,258894,79617,332431,25156,748863,479067,620723,865397,896976,968687,793462,706383,294848,559138,338472,989697,375792,297674,937862,558028,814538,409421,141279,787986,653013,770694,763904,402582,444764,452258,343752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]