SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515574 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515574 [ RunTime:0.002755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358353,837555,311628,1015500,455892,915385,961668,490097,4347,182682,148973,386347,878910,535007,740419,805112,852298,1032707,197113,1034799,425179,693199,375642,480220,923118,867319,345122,851603,302162,289987,910161,26702,984514,742191,187552,735613,93692,337741,611840,677248,685349,289239,362250,805066,1004653,132696,11084,453217,191783,548014,364600,122880,871222,305602,996623,464587,542725,850020,268468,610125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515574 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515574 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]