SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190451 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190451 [ RunTime:0.003973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045412,536764,654743,176275,226658,844660,155957,263178,329550,727491,32295,453061,753121,466061,901075,289921,907805,262486,573015,50435,244329,787739,164455,568466,311605,632243,175595,930792,939628,214664,864966,984761,791408,576453,835520,12186,967184,701472,16830,888100,677171,756358,857736,459554,782932,787645,1024532,659444,27139,800285,1044136,389600,209139,1022192,470143,907939,609673,618668,45409,515706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]