SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471881 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471881 [ RunTime:0.002045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717726,17041,654690,783771,463989,226776,228512,20750,798767,71684,414667,718149,664708,494606,126894,542595,582625,415709,49682,745397,188954,278903,7729,804665,735887,385503,733286,889507,581274,821854,87471,37568,502567,407623,819016,975323,545831,64703,1033117,340144,893725,103497,45785,450471,188653,739604,624915,271201,414480,516756,666865,22931,261212,662685,488937,879781,253474,859530,7689,12231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]