SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 592984 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 592984 [ RunTime:0.002331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351199,600978,577766,501300,551024,676661,476016,845395,586799,729531,492241,591424,830396,385858,593714,595056,1043033,978775,480401,461070,724412,750383,553909,505841,913366,1020196,703283,918944,797963,920779,702215,67756,138740,933228,271988,530109,430645,590705,54973,91471,692656,982133,581591,810747,45286,42475,858610,488557,143579,357357,921585,470275,965742,975012,526131,941024,195343,442050,803209,7438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002814s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 592984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 592984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]