SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014478 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014478 [ RunTime:0.001901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258369,912892,604972,188399,912300,1046122,572906,486705,188889,254876,158086,9187,123912,766186,959100,694505,609717,782835,486721,926743,870679,305946,409388,49498,733310,80199,709697,131307,192625,385218,181432,595782,789966,599724,70691,886148,242509,628505,914237,671840,1014520,242846,45032,412081,75530,995658,698495,260594,1012822,654988,142524,284218,84158,87447,959196,78268,493997,379384,1037767,696508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]