SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450573 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450573 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836879,502307,134329,913290,564312,973551,217784,481119,818848,224619,239032,767560,539564,837451,871981,776756,545026,296883,758293,650701,95944,750916,675824,862359,574960,493853,120845,566840,646783,212261,896668,815813,7064,971469,256050,606989,826164,350021,76547,1042497,318994,652880,350266,753357,357309,978317,471308,861348,280496,66769,263017,492623,323875,157810,771453,486074,213926,373525,604514,941808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]