SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011310 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011310 [ RunTime:0.002320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195891,936486,605741,161471,257773,653961,39948,34449,800531,291171,755518,145596,873500,637196,455432,784407,561317,861711,849133,728015,845760,464004,756472,1026563,135707,198603,17153,361312,647428,453317,553937,686059,756665,82918,703634,616243,77839,159448,417380,3185,111323,277922,1023017,1001091,154868,980342,439784,375063,955455,342519,406447,777514,540123,577253,582774,1004056,192137,385316,803090,322446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]