SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199814 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199814 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15283,548152,777454,715425,154052,935613,526460,177727,691359,256039,971041,172166,564626,667638,387575,771911,972453,413337,772657,330593,153378,369537,497680,747120,649496,778929,405184,952921,45419,749462,787960,634673,513608,923156,839903,53847,260820,928480,231858,435865,400148,37359,167040,526244,654324,206928,3927,778718,345142,504482,113670,992753,825404,758324,629805,566071,1021295,972087,528625,549073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]