SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008021 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008021 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037126,584957,255028,72488,696375,582656,996574,638118,771619,531383,44477,749952,733469,979796,590322,220615,198939,842225,574051,3691,455299,111645,550045,963256,1004862,842052,977483,672920,926039,873063,38064,603923,690088,1013017,740756,915997,248374,859316,553231,391393,785675,363856,349955,696976,119693,647351,1045878,957122,700578,268647,301766,598453,701001,15908,961522,560564,491624,1034662,378396,972767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]