SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68101 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68101 [ RunTime:0.002151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691339,694165,994686,290734,591260,614257,70942,440637,138438,971758,230444,562262,1024919,410915,73609,133068,312375,309886,366776,520926,1012419,1019424,319342,878164,239413,800772,28489,142928,1022917,478352,79120,365581,159632,408335,793380,479322,15286,993646,549203,616440,708706,900638,790057,404909,166549,216652,949113,402340,217920,926756,514260,359190,835050,35460,995985,615736,421202,516046,328655,640533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001829s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]