SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022938 LIMIT 1 [ RunTime:0.000840s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022938 [ RunTime:0.002528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436864,189532,1006905,969584,815144,868104,146131,54810,37428,286316,752134,987229,702694,615717,827413,106198,891241,799468,333691,103196,421406,982613,581038,915015,378026,123016,82988,239422,859873,924296,398079,713527,949525,349111,536680,1032589,159736,804270,44654,602279,230575,614243,285391,581374,27573,101568,639209,455804,833543,647888,306344,757739,972239,212154,944756,89922,518130,703451,65846,238239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]