SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518098 LIMIT 1 [ RunTime:0.000571s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518098 [ RunTime:0.002271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358550,857909,392286,964687,259110,684383,820882,958292,532336,753631,605116,33825,370801,525361,285276,109185,402773,984639,44822,1004135,647462,389019,652223,631987,151762,926612,319433,759498,489271,521996,733404,357341,246223,695131,73724,471097,908686,856309,687043,393873,771733,511340,835149,831396,577365,883461,394409,897070,758429,897373,438803,5190,74476,306273,809473,42625,66105,873065,1008650,464644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002173s ]