SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001768s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475158 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475158 [ RunTime:0.002326s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315445,924933,944692,544963,489696,996795,428316,570982,1000349,626425,748894,477868,762486,144516,442359,331261,122815,558820,465529,409169,395032,642324,974541,267144,461282,684741,764998,780240,211057,408737,491982,88007,144510,520590,314271,659445,90865,756969,849753,890529,954273,382856,877777,177224,163983,641671,871635,704524,335506,685083,1035291,378357,469926,60091,309804,827057,307872,984757,222983,670867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]