SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520149 LIMIT 1 [ RunTime:0.001007s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520149 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521809,623186,410942,572712,840546,976611,1001203,260880,1028877,204727,556537,1019714,105472,844822,417541,753385,215458,553226,789238,486243,93511,841013,837610,58715,91476,200758,1001460,245546,856834,1044849,317115,489987,252074,114566,922148,266614,281129,760832,816848,87312,957360,192923,854801,1024629,699890,664188,934312,251698,286941,429253,320733,271882,624636,591415,666649,878736,765451,837952,45623,357630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520149 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520149 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]