SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407223 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407223 [ RunTime:0.001429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395668,755174,357833,79765,657991,500656,853937,260467,583358,2822,955568,412872,607152,949871,831956,555232,2272,565502,347205,98,1034907,761092,137084,266253,759133,708857,358823,325013,235222,509057,318853,670525,855273,971321,1010018,479985,551437,299138,507140,289643,788607,1033647,379316,140582,473016,848189,850062,93229,293544,382008,661800,822809,1032358,278126,293874,901795,991501,828498,946668,97697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]