SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002527s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512710 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512710 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685350,754496,120700,945990,111243,579867,599091,452409,1039796,422881,501180,680143,401445,783427,881491,1010599,412189,543197,1029503,323704,598230,214756,296081,498778,419178,537681,304102,407559,429889,767811,608960,24438,413031,112769,472017,604040,592832,41477,615939,365634,144681,570627,988519,1041710,440656,683098,892387,140972,872778,598291,402967,469031,306795,808814,347317,705166,1039983,284802,51929,275542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001887s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000705s ]