SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028031 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028031 [ RunTime:0.003773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984230,960564,754283,48672,649400,292461,79141,470377,664275,845032,1035451,813519,193032,428704,539175,625174,948268,738251,1035109,412712,765382,391940,859145,79805,1038933,822286,772512,544104,889236,643256,507315,666541,107665,172208,391007,699766,267062,978089,15499,328290,892622,663909,186600,801715,875445,528431,727537,633752,619383,878984,492504,136331,273506,93971,809934,342832,303495,980847,601649,824588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001728s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000780s ]