SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563238 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563238 [ RunTime:0.002627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43180,899684,945964,997315,412360,1031329,1038485,258343,613913,927076,306383,570120,916265,480787,807465,821405,327025,596177,447544,523465,305136,122170,84505,101527,46493,802647,599830,188598,488620,804344,826284,502525,58504,136019,430446,626690,981982,906263,470513,140858,21948,732426,358009,380654,96936,199982,66041,1042966,632839,398354,254158,233756,945310,834326,721961,411988,888134,408052,623973,594474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002984s ]