SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415633 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415633 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489147,191233,825081,54960,450267,1023761,840438,487608,34037,783420,114969,409196,787021,827584,825880,157159,279877,988133,628407,409669,615313,867708,479615,819418,755866,678900,887100,561135,97497,358796,868415,363478,126939,914179,432612,716346,820140,942750,1001439,497030,893291,1038949,84321,187686,56475,843425,6827,903382,275515,846587,798911,271555,979315,1034522,660394,305912,866488,619675,1042359,942669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415633 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415633 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]