SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005039 LIMIT 1 [ RunTime:0.000626s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005039 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317390,1000404,350220,679848,1041213,521214,174764,1017747,940268,36312,759796,610507,515951,383229,770357,813965,1037378,413896,1005728,353853,280623,729666,559747,343046,27490,946861,546203,626377,350761,805045,490690,123774,351057,180897,1006344,375927,915790,451747,515573,964385,1045644,375768,645593,179453,481744,634124,651526,619812,501571,509177,193878,474612,440004,774390,21422,682358,7593,354631,620532,724476) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]