SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006860 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006860 [ RunTime:0.003525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722643,689701,537991,845435,197880,22926,677471,419186,409547,470990,661235,765646,201535,975926,518878,905041,495155,121697,744381,181558,475047,458462,734914,606099,177899,468195,247467,37287,404571,543863,499391,188638,301760,618719,104727,204671,718142,314493,384904,238815,897336,925592,240364,859602,198215,301992,681987,458656,266535,262286,829156,986868,782701,100134,82300,944699,297613,407661,123304,938565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]