SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31141 LIMIT 1 [ RunTime:0.000666s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31141 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938980,165470,770325,707709,949044,446674,1011074,86336,476777,281139,1021790,436412,110976,783189,898017,929404,750938,744373,527185,481735,735917,630449,641293,104221,194321,373566,745230,481002,994459,114303,368351,850118,175456,637614,219623,207644,878052,200386,99439,645065,648897,181884,676160,153781,402409,588317,465266,214267,984397,323323,842294,478362,1029722,214576,356475,397682,637658,92997,495706,1025578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]