SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492511 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492511 [ RunTime:0.002378s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202378,787804,942533,502703,276900,550797,863161,892164,567847,1043351,1031861,443703,179764,960421,87033,254156,866114,259608,681584,110324,816861,655351,961640,465029,181529,11159,361758,902402,248893,305040,234307,983634,702038,486921,129784,278535,701984,603656,6519,744863,725063,736747,40069,746286,372258,455696,386597,31773,656584,544363,13461,939474,975763,734080,588091,404170,916577,797155,297948,714304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000751s ]