SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493640 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493640 [ RunTime:0.001940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486628,645431,401762,211151,610564,371182,366533,978853,19959,785035,54416,282016,134425,2554,239461,798500,687238,812195,129842,62992,755791,628661,244356,674821,673709,752515,351935,1009466,689179,18456,354260,555024,638105,1030532,108636,791484,431287,213972,957132,27279,191308,846777,114190,82539,869809,993836,212088,976797,975762,251670,180840,1043746,788463,452822,789997,903037,77002,417414,969175,354866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]