SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504596 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504596 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780481,486453,70581,217138,873077,287556,32148,780088,805678,131202,846356,50693,514331,229389,301240,16491,733583,994043,839199,584923,932593,653728,192674,1035352,409016,594965,480716,865824,157715,124823,632522,473982,432296,275096,249182,834302,505922,990067,380264,259501,851669,395303,694668,799299,173581,1002337,317740,835410,195996,356653,988237,693173,333700,177744,1044401,335188,674955,244272,310147,823503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]