SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294160 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294160 [ RunTime:0.002416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945790,388163,866234,326473,952015,73558,42816,285394,1037382,437968,786868,194447,821274,879892,760139,149853,870049,971955,246503,9375,13728,570038,845916,664177,582136,289297,570687,694986,1034520,787846,528913,309760,19516,281219,838493,786522,642500,728939,954615,834490,673173,627543,115024,492290,266339,464491,333753,1033116,647093,483610,215959,32198,398137,47256,165716,638359,397159,497658,627751,890765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]