SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509228 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509228 [ RunTime:0.002222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693296,1035171,746983,554992,34387,319019,376073,292459,718662,908189,22243,331948,772684,574885,412964,231898,863387,324523,691796,473534,962030,907428,749002,1036478,747585,729421,521744,304865,928015,466349,1010967,297470,1019094,279336,941660,821633,323576,568771,725455,79818,445142,475781,400919,991692,471357,130864,662765,197247,54208,398302,965863,346122,791343,510439,843850,805838,110766,472873,339298,917437) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]