SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030125 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030125 [ RunTime:0.001460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11021,412217,755182,237818,588356,697402,851907,271421,424171,248200,952445,782512,1017256,938500,534030,185358,723780,347736,135889,528357,405876,287459,449964,772948,357628,28382,743000,657415,732399,968366,1037090,168119,445272,345107,619931,922852,410555,451779,588172,378381,4748,886789,520133,214377,15600,832573,987514,404569,461827,102625,757107,458543,120688,436841,929739,254795,790573,983160,772609,887956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030125 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030125 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]