SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557591 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557591 [ RunTime:0.001527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047416,923333,1026631,523113,931646,48776,133247,459478,889523,346550,938774,528240,532709,543187,481916,794392,112230,422292,984025,261251,263151,950358,471574,739481,666365,502006,197035,835322,967215,278251,119243,515452,777222,891056,796172,204747,904081,850944,1003974,987925,106186,760907,480428,949962,340766,114873,16303,994782,18038,995885,372646,643352,138349,212667,280218,831435,288932,795876,196668,536421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]