SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042991 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042991 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332385,1024974,251543,371817,224438,398132,808932,42810,341604,955486,206580,733896,810475,468649,175177,640767,857487,836678,392152,796034,720557,984553,10836,441558,134161,618291,110552,245551,14838,21285,171342,484860,74342,260925,380262,612913,368161,842704,328668,472652,965251,614154,683417,897299,565150,788904,897415,992410,584159,530725,107050,212720,391490,924669,802351,37814,208799,884482,727719,369662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]