SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002519s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563932 LIMIT 1 [ RunTime:0.002084s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563932 [ RunTime:0.002066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353458,404269,450362,413948,148312,288451,775553,773957,243412,458364,965654,138174,510702,10720,1048242,453010,239220,1035633,1006473,415357,828953,811662,467649,247468,959209,99746,237957,836122,88338,679766,1031218,120985,248486,857345,205401,828969,530083,336259,849851,94159,645477,320218,16958,226881,348644,850024,611161,445443,139754,1013660,455080,550140,908757,498673,679535,823076,879544,762569,172019,639252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563932 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563932 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]