SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043908 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043908 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (823712,943421,413388,935350,931582,516695,319934,867871,866500,614770,1043609,811723,812495,953707,507066,334920,6612,672050,442825,48720,730199,831519,896416,839499,664357,723740,706291,412388,753484,129140,367230,338060,651077,550932,767435,190430,696217,530340,621570,621528,251247,910137,167375,879565,158853,796739,156573,364607,568224,735047,120889,374675,170521,903214,778606,727645,119154,763837,367616,204580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]