SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510903 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510903 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225866,423129,29043,216004,604731,120816,728461,786005,213107,998866,689034,486988,554313,52501,307043,325518,130743,551434,177226,770762,741695,606820,276829,1041760,216682,691597,523264,830185,218070,1034186,999549,1022650,774092,470274,120686,503106,919290,468684,428138,280829,965935,549292,958753,1028247,1025278,358651,765266,235409,836045,320797,463845,794922,167025,550336,524282,748083,734378,105900,418020,440954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]