SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000540 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000540 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265096,748622,971172,674046,121365,494834,799778,133904,288126,2178,1045338,391069,849192,606008,582890,58400,579572,94724,442878,859670,879079,1032225,348826,507327,899416,201242,679189,141716,576591,34609,476778,460304,144989,206328,668066,692736,821605,264017,13880,1037187,930783,747146,447609,331111,50686,793944,740887,907687,411166,78063,496137,425208,947339,453781,888324,946004,127570,484588,992705,933896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]