SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482701 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482701 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647091,468858,130843,711569,131680,996072,282038,222205,776732,733949,135813,66513,152647,1026013,405449,345999,206631,31720,294486,608230,318082,299833,980083,847259,224042,554381,1005603,1008904,726087,802917,590779,669204,124835,58411,223046,890430,189944,216501,77455,498298,654236,237538,442507,369264,470050,242057,776712,281378,366367,647843,338926,831641,862378,353347,392833,703098,541810,965830,201764,878327) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]