SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001728s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526291 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526291 [ RunTime:0.003035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424804,785809,869504,1025530,347854,243946,997640,171164,481979,1001222,660557,626612,301144,25445,256126,823832,985776,163002,214674,361023,994216,635148,992820,37344,233749,828274,668668,255208,1001832,429682,73330,477402,973096,828712,465310,274390,369191,613649,18713,517286,271584,613944,396039,314967,517854,333066,170876,118405,837229,113241,79840,1021185,99277,1011409,1006003,423422,954533,446523,460242,823545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]