SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039754 LIMIT 1 [ RunTime:0.000720s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039754 [ RunTime:0.003165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946434,859686,361040,1017372,804216,696854,939470,841428,251775,349194,167696,820550,891733,569595,761920,549597,546302,688913,157089,878111,512240,1014560,1031909,379052,93818,361025,199283,20794,597943,414070,891083,492036,198171,183927,751963,426948,941707,317108,592738,213338,889741,572551,645172,13162,465938,177320,646174,413789,811475,898277,517073,17471,611145,425783,144253,672733,946134,236827,367760,763731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]