SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345703 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345703 [ RunTime:0.002508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918465,753694,420486,228392,615524,407658,200804,43337,817553,75192,226201,897448,318822,423338,612965,807749,413969,181764,951930,832316,945700,1005634,981997,1030340,147447,595326,444126,916926,277418,556234,552066,426106,385800,922958,130136,31015,858898,962326,365599,83057,131497,36783,16893,870743,677422,793393,893098,987032,1009493,872656,121140,827836,471751,226848,273845,924416,843250,550320,729380,682270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001411s ]