SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461896 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461896 [ RunTime:0.002637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039570,282508,512775,851708,820811,640212,734072,491018,138470,265645,73606,405501,961360,415250,447481,108341,908082,910221,58630,384839,739155,157884,793672,512002,842878,475823,458150,723082,1007762,955585,267111,394048,347454,471896,356667,7468,1045000,799062,180150,689367,993411,749348,900640,196192,11693,888301,161017,969235,647808,836773,861734,233516,13171,364037,219197,14158,249809,262747,750538,908112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]