SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533160 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533160 [ RunTime:0.003253s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (22261,464676,1045957,171078,634991,469984,411483,192248,965739,278017,420097,112815,605876,776891,937624,635868,576286,259053,776955,923465,893786,153733,607291,411020,726744,660977,678738,61964,113539,723207,901432,279276,308817,174227,849610,311825,701878,119977,1011637,683725,595433,544632,324585,394451,425232,215649,935293,881788,285827,900821,457612,43586,989502,281321,758347,993268,567977,218684,476053,1018033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]