SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533938 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533938 [ RunTime:0.003460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773238,886924,702675,323669,600332,133003,195254,59350,317103,380518,598615,680522,158905,247441,822439,63354,181256,582994,865175,408390,605691,843821,541265,1017134,140755,987246,231820,939660,489528,985838,147649,984507,482798,31132,717201,43272,938142,632893,670134,27668,527071,465848,943988,344065,281836,762264,652857,241681,503128,893247,182084,576345,21035,801422,989735,842657,993581,1021825,387543,643089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003321s ]