SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048264 LIMIT 1 [ RunTime:0.001199s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048264 [ RunTime:0.002939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186023,428133,283211,389643,313735,420502,322219,711126,637914,777034,951622,937202,330121,732517,844512,497048,29563,436364,573240,11958,375373,407776,365071,1041612,280597,461744,108802,637491,749223,492996,430243,818794,203730,878657,408951,103762,199123,869449,304558,564211,990239,1002211,894397,881297,118858,403906,436201,623194,723598,173953,727658,974137,236123,602319,937144,790761,436280,1036611,154981,319417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048264 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048264 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002128s ]