SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245411 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245411 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196276,573171,778959,266541,127004,621727,743707,563581,861741,438506,591500,287944,1029870,759982,363113,842225,871961,421703,145719,227856,150011,437611,1009625,608640,7568,927551,179219,740453,437092,433767,1035957,228181,98343,333549,712330,629183,191311,818267,328015,650148,639538,803574,750026,241021,762599,912781,257428,478617,583664,493811,67279,709210,345747,552374,53611,598675,687545,753932,857763,808368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]