SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002511s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349047 LIMIT 1 [ RunTime:0.003881s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349047 [ RunTime:0.005246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362784,428507,721208,884022,264705,480530,863665,932502,64454,55194,621234,304954,45666,503727,10872,727675,628554,469791,651461,702021,724768,586000,294050,195102,216556,651616,551017,845640,616145,844787,532924,288048,397557,166015,480429,842947,295742,483158,213791,333974,391150,886208,541145,2613,660116,267711,271246,400386,180892,555928,118585,952989,1048355,244614,951438,722925,919986,550220,148938,379580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]