SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042506 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042506 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134006,515039,690981,362341,503393,945444,115605,170229,811453,673913,968435,253619,31175,965555,264825,1021138,798936,993847,142209,147048,343513,447285,396565,452982,887471,491455,753869,527342,617597,445440,682291,135468,690729,347839,548959,488699,474747,937304,800717,820306,511631,604164,339213,550927,762768,102680,83943,573889,653354,685424,953031,703359,926205,650221,812927,649689,908921,611413,789376,500369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000721s ]