SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579040 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579040 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171104,522717,849633,92780,714621,735714,480066,159845,200374,1008738,124589,588658,669624,230967,255109,183894,136364,171642,109696,889524,450195,92088,234637,358153,56833,783911,718491,388313,686994,68759,285588,572179,381133,562804,924469,796402,46338,450873,949356,543211,629317,740480,892354,891514,768495,1033064,152685,393932,645156,245726,29939,472967,781838,48876,790735,283851,700810,431989,742450,274625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]