SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530514 LIMIT 1 [ RunTime:0.000560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530514 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138012,401522,803036,162023,875047,550560,436249,475570,108882,73310,58153,125807,691506,616757,334438,375983,490515,759702,311359,852032,842965,124690,917029,403482,260111,785422,1020259,4362,358601,212441,889253,123623,707424,776195,903225,368276,954358,302468,107520,295977,955656,784369,139666,9687,837639,152304,239643,336363,573653,191591,841746,661452,994406,404404,699259,34569,1013603,379984,157242,374602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]